﻿23.4.2013 16:11:19
select * from [User] where nameLogin = @nameLogin and password = @password

23.4.2013 16:11:19
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('23.4.2013 16:11:19', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

23.4.2013 16:11:19
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

23.4.2013 16:11:23
select * from role order by name

23.4.2013 16:11:23
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

23.4.2013 16:11:23
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

23.4.2013 16:11:23
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

23.4.2013 16:11:23
select * from role order by name

23.4.2013 16:11:25
select * from role order by name

23.4.2013 16:11:25
select * from role order by name

23.4.2013 16:11:25
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

23.4.2013 16:11:27
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

23.4.2013 16:11:27
select * from company order by name

23.4.2013 16:12:28
UPDATE [User] SET 
IdCompany = 4, 
 Notes = 'Testovani Mario', 
 Phone = '123 456 777', 
 Email = 'mariomalicher@seznam.cz', 
 Address = 'Olomouc', 
 NameLogin = 'Mario', 
 Password = '', 
 Name = 'Mário', 
 Surname = 'Malicher'
 WHERE idUser = 1 

23.4.2013 16:12:28
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

23.4.2013 16:12:28
select * from company order by name

23.4.2013 16:12:36
select * from role order by name

23.4.2013 16:12:36
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

23.4.2013 16:12:44
UPDATE [User] SET 
idRole = 5
 WHERE idUser = 5 

23.4.2013 16:12:44
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

23.4.2013 16:13:05
select * from role order by name

23.4.2013 16:13:31
UPDATE Modul SET 
nameModul = 'Testovaci submodul 2.2', 
 idParent = '2', 
 orderModul = '1', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_2.2', 
 userMod = 1, 
 dateMod = to_date('23.4.2013 16:13:31', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 7 

23.4.2013 16:13:31
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

23.4.2013 16:13:58
UPDATE Modul SET 
nameModul = 'Testovaci submodul 2.2', 
 idParent = '2', 
 orderModul = '0', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_2.2', 
 userMod = 1, 
 dateMod = to_date('23.4.2013 16:13:58', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 7 

23.4.2013 16:13:58
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

23.4.2013 16:14:15
UPDATE Modul SET 
nameModul = 'Testovaci submodul 2.2', 
 idParent = '2', 
 orderModul = '1', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_2.2', 
 userMod = 1, 
 dateMod = to_date('23.4.2013 16:14:15', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 7 

23.4.2013 16:14:15
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

23.4.2013 16:14:40
UPDATE Modul SET 
nameModul = 'Testovaci modul 5', 
 idParent = '0', 
 orderModul = '0', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_5', 
 userMod = 1, 
 dateMod = to_date('23.4.2013 16:14:40', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 8 

23.4.2013 16:14:40
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

23.4.2013 16:14:55
UPDATE Modul SET 
nameModul = 'Testovací modul 1.2.2', 
 idParent = '16', 
 orderModul = '50', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_1.2.2', 
 userMod = 1, 
 dateMod = to_date('23.4.2013 16:14:55', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 20 

23.4.2013 16:14:55
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

23.4.2013 16:15:03
UPDATE Modul SET 
nameModul = 'Testovaci submodul 2.2', 
 idParent = '2', 
 orderModul = '0', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_2.2', 
 userMod = 1, 
 dateMod = to_date('23.4.2013 16:15:03', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 7 

23.4.2013 16:15:03
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

23.4.2013 16:15:10
select * from Rights where idModul = 7

23.4.2013 16:15:10
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

23.4.2013 16:15:12
select * from role order by name

23.4.2013 16:15:12
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

23.4.2013 16:15:13
select * from role order by name

23.4.2013 16:15:21
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

23.4.2013 16:15:21
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

23.4.2013 16:15:21
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

23.4.2013 16:15:30
INSERT INTO Rights ( visible, 
adding, 
edit, 
remove, 
printing, 
specialFiltration, 
idRole, 
idModul) VALUES (  0, 
 0, 
 0, 
 1, 
 1, 
 1, 
 1, 
 18) ; SELECT @@Identity

23.4.2013 16:15:48
INSERT INTO Modul ( nameModul, 
idParent, 
orderModul, 
sqlQuery, 
nameApplication, 
parametersApp, 
userAdd, 
dateAdd) VALUES (  '', 
 '', 
 '60', 
 '', 
 NULL, 
 NULL, 
 1, 
 to_date('23.4.2013 16:15:48', 'dd/mm/yyyy hh24:mi:ss')) ; SELECT @@Identity

23.4.2013 16:15:48
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

23.4.2013 16:15:56
UPDATE Login SET 
logout = to_date('23.4.2013 16:15:56', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 365 

23.4.2013 16:16:07
select * from [User] where nameLogin = @nameLogin and password = @password

23.4.2013 16:16:07
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('23.4.2013 16:16:07', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

23.4.2013 16:16:08
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

23.4.2013 16:16:13
select * from role order by name

23.4.2013 16:16:13
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

23.4.2013 16:16:13
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

23.4.2013 16:16:13
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

23.4.2013 16:16:13
select * from role order by name

23.4.2013 16:16:15
UPDATE Login SET 
logout = to_date('23.4.2013 16:16:15', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 366 

23.4.2013 16:16:26
select * from [User] where nameLogin = @nameLogin and password = @password

23.4.2013 16:16:27
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('23.4.2013 16:16:27', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

23.4.2013 16:16:27
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

23.4.2013 16:16:31
select * from role order by name

23.4.2013 16:16:31
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

23.4.2013 16:16:31
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

23.4.2013 16:16:31
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

23.4.2013 16:16:31
select * from role order by name

23.4.2013 16:16:33
UPDATE Login SET 
logout = to_date('23.4.2013 16:16:33', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 368 

26.4.2013 11:50:52
select * from [User] where nameLogin = @nameLogin and password = @password

26.4.2013 11:50:52
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('26.4.2013 11:50:52', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

26.4.2013 11:50:53
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

26.4.2013 11:50:54
select * from role order by name

26.4.2013 11:50:55
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

26.4.2013 11:50:55
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

26.4.2013 11:50:55
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

26.4.2013 11:50:55
select * from role order by name

26.4.2013 11:50:56
select * from role order by name

26.4.2013 11:50:56
select * from role order by name

26.4.2013 11:50:56
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

26.4.2013 11:50:57
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

26.4.2013 11:50:57
select * from company order by name

26.4.2013 11:51:05
UPDATE Login SET 
logout = to_date('26.4.2013 11:51:05', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 372 

26.4.2013 14:51:41
select * from [User] where nameLogin = @nameLogin and password = @password

26.4.2013 14:51:42
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('26.4.2013 14:51:42', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

26.4.2013 14:51:43
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

26.4.2013 14:52:09
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

26.4.2013 14:52:12
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

26.4.2013 14:52:12
select * from company order by name

26.4.2013 14:52:12
select * from company order by name

26.4.2013 17:11:50
UPDATE Login SET 
logout = to_date('26.4.2013 17:11:50', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 373 

